CREATE TABLE [dbo].[NavigationExport]
(
[NavigationKey] [uniqueidentifier] NOT NULL,
[NavigationStatusCode] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[NavigationTitle] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[NavigationName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[NavigationDescription] [nvarchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NavigationAttributes] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BreadCrumbName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OverrideContentTitle] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NavigationPane] [int] NOT NULL,
[OpenInNewWindowFlag] [bit] NOT NULL CONSTRAINT [DF_NavigationExport_OpenInNewWindowFlag] DEFAULT ((0)),
[WorkflowDocumentKey] [uniqueidentifier] NULL,
[IsHidden] [bit] NOT NULL CONSTRAINT [DF_NavigationExport_IsHidden] DEFAULT ((0)),
[PublishedDateTime] [datetime] NULL,
[PrePublishURL] [nvarchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PostPublishURL] [nvarchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PublishedDirectory] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ParameterList] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NavigationCode] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ContentKey] [uniqueidentifier] NULL,
[IsActive] [bit] NOT NULL CONSTRAINT [DF_NavigationExport_IsActive] DEFAULT ((1)),
[IsHTTPS] [bit] NOT NULL CONSTRAINT [DF_NavigationExport_IsHTTPS] DEFAULT ((0)),
[AddKeyToURLFlag] [bit] NOT NULL CONSTRAINT [DF_NavigationExport_AddKeyToURLFlag] DEFAULT ((1)),
[IsExpandedByDefault] [bit] NOT NULL,
[CreatedByUserKey] [uniqueidentifier] NOT NULL,
[CreatedOn] [datetime] NOT NULL,
[UpdatedByUserKey] [uniqueidentifier] NOT NULL,
[UpdatedOn] [datetime] NOT NULL CONSTRAINT [DF_NavigationExport_UpdatedOn] DEFAULT (getdate())
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[NavigationExport] ADD CONSTRAINT [PK_NavigationExport] PRIMARY KEY CLUSTERED ([NavigationKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_NavigationExport_CreatedByUserKey] ON [dbo].[NavigationExport] ([CreatedByUserKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_NavigationExport_UpdatedByUserKey] ON [dbo].[NavigationExport] ([UpdatedByUserKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[NavigationExport] ADD CONSTRAINT [FK_NavigationExport_UserMain_CreatedBy] FOREIGN KEY ([CreatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO
ALTER TABLE [dbo].[NavigationExport] ADD CONSTRAINT [FK_NavigationExport_UserMain_UpdatedBy] FOREIGN KEY ([UpdatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO